<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>WIKINDX CLASS DOCUMENTATION</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="/wikindx2/docs/docs.css" type="text/css" />
</head>

<body bgcolor="#FFFFFF" text="#000000">
<h2>WIKINDX METHODS</h2>
<p><strong>Method:</strong><br />
  
  limit()
</p>
<p><strong>Class:</strong><br />

  <a href="sqlClass.html">SQL</a>
<p><strong>Method Call:</strong><br />
  include_once("core/sql/SQL.php");<br />
$db = new SQL();<br />
ADODB_RECORDSET $db->limit(STRING: $selectSQL, INT: $limit, INT: $offset); </p>
<p><strong>Description:</strong><br />
  
Execute a SELECT statement with a LIMIT clause.  </p>
<p>The return is an ADODB_RECORDSET suitable for passing to the <a href="fetchRowMethod.html">fetchRow()</a>, <a href="loopRecordSetMethod.html">loopRecordSet()</a> or <a href="fetchOneMethod.html">fetchOne()</a> methods etc. If it fails to execute the query, the script will exit with an error message. </p>
<p><strong>Usage:</strong><br />

For example (assuming the database object exists within a class as $this->db), the following will return 22 records starting at offset 12 (offsets are numbered from 0):
<pre>
	$selectSql = $this->db->selectNoExecute(array("WKX_resource"), array("title"));
	$recordset = $this->db->limit($selectSql, 22, 12);
</pre>
<p align="right"><a href="../../index.html">WIKINDX home</a>
&nbsp;&nbsp;&nbsp;&nbsp;
<a href="../../usage/index.html">WIKINDX usage</a>
&nbsp;&nbsp;&nbsp;&nbsp;
<a href="../index.html">WIKINDX classes</a>
</p>
</body>

</html>
